Adding Data Source

Adding Data Source

supOS supports access of multiple data sources such as MySQL, SQL Server, Oracle and more. With the connected data source, you can dump the supOS data to databases in real time and call data during APP development.

1. Log in to supOS, and then click at the upper-right corner to go to the design center.
2. Select Global Configuration > Data Source Management, and then click New.
3. Select a type of data source, and then enter the data source information in the pop-up window.

info

MySQL is used as an example in this section.

Parameter	Description
Data Source Name	Enter the name and description of the data source. The maximum length of the name and description is 20 and 100 characters respectively.
Data Source Description
Server Address	The IP address and port of the database server.
Server Port
Database Name	Enter the name of the database, and the username and password to log in to the database. info Make sure the database exists on the server.
Username
Password
Timezone	Enter the time zone of the data source.

4. Click Connection test.
5. Click Confirm after the successful connection notification pops up.

• Select multiple data sources, and then click Test Connectivity at the top to test connection in batches.
• Click Edit or Delete under Operate to edit or delete the data source.
  info

  The data source that has been using cannot be deleted.

• to refresh the data source list to check the connection status in time.